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