UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 's4jef0TqR9KiMPciyDaBGMg3nILzKiPTkgOr5g9AJPU='
WHERE
key_id = 'a419ff457ad00583ab14bdbce46a56509850a3f8ffdad4887757aa9affd420c3'
AND (
token = 's4jef0TqR9KiMPciyDaBGMg3nILzKiPTkgOr5g9AJPU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)