UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+KPK8boNzwcpu7ONnKBp0kNTHGkkDCRykI/MsHju1jM='
WHERE
key_id = 'cae27cfaffe65d1af9b138f57b00e6d75f5d711dcd0c93dc93f40283c0a6e2dc'
AND (
token = '+KPK8boNzwcpu7ONnKBp0kNTHGkkDCRykI/MsHju1jM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)