UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VhtQj2MZXkK9Vq8RZUDgh5z5zTJJVB/vSYiT3SgBuoQ='
WHERE
key_id = '87456c13b95e77d2962a7a3565ddecf96cfe4f116516c0fe4347ecb58ccc3193'
AND (
token = 'VhtQj2MZXkK9Vq8RZUDgh5z5zTJJVB/vSYiT3SgBuoQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)