UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gRevv+VsyW1e1mlB4V1Tv+58BNfKoMnusSGxm6ez1KM='
WHERE
key_id = '47d574f852e61e52c7076954973b9987d355ee8c1a244b9df87cdaba7b7982cd'
AND (
token = 'gRevv+VsyW1e1mlB4V1Tv+58BNfKoMnusSGxm6ez1KM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)