UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/QdZdVyo6M3z9bj90WRdxrtzTtCTWT4t3xbBU5FfHDg='
WHERE
key_id = 'b14be8e03feebd35d024152495a6fc980e8932956efdc270eb58ee7bb57ae3fb'
AND (
token = '/QdZdVyo6M3z9bj90WRdxrtzTtCTWT4t3xbBU5FfHDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)