UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SndyuCozzZn639T4uJXcN14FHFmgpMEAVkmza1OSGdU='
WHERE
key_id = '8b27063dcd627a32168916ec52c46f2d880d50bb88fa639f2cdf66ee9cb3dc4d'
AND (
token = 'SndyuCozzZn639T4uJXcN14FHFmgpMEAVkmza1OSGdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)