UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EwQ9phiPcIwz9etBkc+IX9noPaHD1pBqcYwkyP9/Oss='
WHERE
key_id = 'f4394db3cfd8c70fabdd816047002407deb8223bd0aeeb8dcec4c7a4d7402ea9'
AND (
token = 'EwQ9phiPcIwz9etBkc+IX9noPaHD1pBqcYwkyP9/Oss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)