UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PkdHX/c2h3CAlKDiW+82HCgiP/gRYLtEfnN28OaJLsE='
WHERE
key_id = 'e9fc612dcc949d94da7a692a338c82ee72382e68e695e6d9f9ad606910a8eaf5'
AND (
token = 'PkdHX/c2h3CAlKDiW+82HCgiP/gRYLtEfnN28OaJLsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)