UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zXbmVFOtfOjAnfBO9/513bcfUr81RjQJc87WU25eOFg='
WHERE
key_id = 'a8ceb704e3b119a16b7c8924a4ad44fb803183f69b81337a2f6a95bf5dc07df3'
AND (
token = 'zXbmVFOtfOjAnfBO9/513bcfUr81RjQJc87WU25eOFg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)