UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3E7wwGwXRltFYbI5MOlEUXiqtb66W575cOV37PC1TWg='
WHERE
key_id = '42d748c86b545d593e4beeb71da2f1f89785367199a129cd88ce1485dd92d06e'
AND (
token = '3E7wwGwXRltFYbI5MOlEUXiqtb66W575cOV37PC1TWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)