UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6rd5RiX4hgxd2xfNF7MySP+4RPNOoXRfkOe3mO4Iz/c='
WHERE
key_id = '9ddab80590e6212de1d1a461fc0cd5b9f0d856b21dd280f796487db25e6bc849'
AND (
token = '6rd5RiX4hgxd2xfNF7MySP+4RPNOoXRfkOe3mO4Iz/c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)