UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0BnOBjpN5GbzMmJqv+Sv5CMXy35Wdw1SDredL4VEI0c='
WHERE
key_id = '7d52e74ba19924e28d0f1bebf8d24ac1708fc701e4ec0d80e820bee934096723'
AND (
token = '0BnOBjpN5GbzMmJqv+Sv5CMXy35Wdw1SDredL4VEI0c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)