UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u9nNktd8J1YlHL4Tx3v5cCDCgjGXYYR75IQISFZ4K0U='
WHERE
key_id = 'c1a65f4b3aac86784bad74e01f5122045581023d2923f732766bad37405a9cbf'
AND (
token = 'u9nNktd8J1YlHL4Tx3v5cCDCgjGXYYR75IQISFZ4K0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)