UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5athawoB50AYHUlbrVcdO5mA6y0LIHhKGqPIPE9+epY='
WHERE
key_id = '988ab2f5e39b38ec76a73d49cfce75317ef696aad71dd65894aac1cf45f42cdf'
AND (
token = '5athawoB50AYHUlbrVcdO5mA6y0LIHhKGqPIPE9+epY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)