UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1nrW9castpPPZaH0UHStodIk7oCie1Gj7jebnr8A5Go='
WHERE
key_id = '5777ec37c7474b8633d108f389cc095fa8acfed06bcf878062cc7d1ee0fe117d'
AND (
token = '1nrW9castpPPZaH0UHStodIk7oCie1Gj7jebnr8A5Go='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)