UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HSG8BNYSdYfAe2t1zL85/XifGR1IZJi8ysDSkJ37LwE='
WHERE
key_id = 'bce4af9a79950866a0b47d268459b34029f0d466cf50f94cf03470649b35722f'
AND (
token = 'HSG8BNYSdYfAe2t1zL85/XifGR1IZJi8ysDSkJ37LwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)