UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5H3qvAbtPAr4uXPM3Lduz3Sra0jb8sozswwK7hj5Grg='
WHERE
key_id = 'b4b420b58a1553878036c13f5ff6102a6aca15d36f45bcaa401929e5aa1c9b4b'
AND (
token = '5H3qvAbtPAr4uXPM3Lduz3Sra0jb8sozswwK7hj5Grg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)