UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I7FJ589+UL6ttEi+Cvvc+nHHy26ry9UasIkmM4vNgWA='
WHERE
key_id = 'afcc7a50ee773ff22945d14869d666275526e539389b388cc085e9454035b5c5'
AND (
token = 'I7FJ589+UL6ttEi+Cvvc+nHHy26ry9UasIkmM4vNgWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)