UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7GPsNJl5l/T2e2mODpPFvoJ9rz4icBwEPU/hGLlQ4qw='
WHERE
key_id = 'b4318c0a106689e7240b1fd8ef4c3ec08daa35ac9e5ddb2387e3d70665a2dbe1'
AND (
token = '7GPsNJl5l/T2e2mODpPFvoJ9rz4icBwEPU/hGLlQ4qw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)