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