UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CtSI+bqHz32tALGib1dRI7bNKQpQqLFj0Mbu+0U6HTI='
WHERE
key_id = 'd472ed7bd17a15488f33f5b11a2693bf4a5c9021640b8195fcab9f8a22ea6e5a'
AND (
token = 'CtSI+bqHz32tALGib1dRI7bNKQpQqLFj0Mbu+0U6HTI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)