UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'au1vvBM3KkEyD9+q5IygWEy3+goUxmS3bpIi7xOPYKI='
WHERE
key_id = 'e1fd9ab369e45d7eace287c9df43836d61899b8adcf64363c200819c3152ee6a'
AND (
token = 'au1vvBM3KkEyD9+q5IygWEy3+goUxmS3bpIi7xOPYKI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)