UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xjfZp3NUwNXcZ+hm45BYYmJl4CPUecS+Qx31KSu8x4Q='
WHERE
key_id = 'aea5a5e82358bec38c03832786e77510641bcce843ff6166cf8c27769a40a3c2'
AND (
token = 'xjfZp3NUwNXcZ+hm45BYYmJl4CPUecS+Qx31KSu8x4Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)