UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BetiL9tss887I7v5gHnMbGokZX3gsGwGmQVzlNyYiBk='
WHERE
key_id = '46d344fd2c212cf50df8c389b5c48361ceb526aa678cfbc0d780f16e35db118a'
AND (
token = 'BetiL9tss887I7v5gHnMbGokZX3gsGwGmQVzlNyYiBk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)