UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PWTBJpgOMGz3y4Dlw+wQluu/NI0ABQYu3+0j5IXviTA='
WHERE
key_id = 'e163f2cb66708fad3bdd17b62695cf831141e77b039c32cb4af5cb26e9cd06cc'
AND (
token = 'PWTBJpgOMGz3y4Dlw+wQluu/NI0ABQYu3+0j5IXviTA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)