UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hL+nG2rVDIu7nE/aFk9WhYh4VLtoqTKaJI57Jcni+gg='
WHERE
key_id = 'be7f8d67298d981b48df5c2f8d13950d6dccbeb4664658fbed2a05c507ff0a64'
AND (
token = 'hL+nG2rVDIu7nE/aFk9WhYh4VLtoqTKaJI57Jcni+gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)