UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b30NvQYC+9qV+neB5zOTZHgitbrK380G9awbR6p+iio='
WHERE
key_id = 'd1ccad3a64fa099e4e568c2e259b2bca107362a3fd989bc1f50a0b99eb707a9f'
AND (
token = 'b30NvQYC+9qV+neB5zOTZHgitbrK380G9awbR6p+iio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)