UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bmuvGgqizmITCG45JywPkXc+V1VJlv10hGZPN2YfHLA='
WHERE
key_id = 'e27d5a811d4954bc09b655889ffb145b1239468fb36179aa0cbd757ca820c843'
AND (
token = 'bmuvGgqizmITCG45JywPkXc+V1VJlv10hGZPN2YfHLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)