UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XHko+AUl8noDG6/xoxDK1ekJ7idrSh/tDIRc8w3wirc='
WHERE
key_id = '657505287eff2db081875c9b0d2cc7426abf2a41dccc11fdadfb41e74c2e4870'
AND (
token = 'XHko+AUl8noDG6/xoxDK1ekJ7idrSh/tDIRc8w3wirc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)