UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XCPc4CJCWQ2oH6PPCNzCTM8Ltqk3I6Bdrr7Iud+zjl0='
WHERE
key_id = '0f2b36a8f317c2f27e2be6d72657255781ff6d4613d4b5fb48b58551f024f743'
AND (
token = 'XCPc4CJCWQ2oH6PPCNzCTM8Ltqk3I6Bdrr7Iud+zjl0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)