UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pUO73cM/+EdIv2DnTrMNDZpEnJu9NoiLSI93RmiKoRU='
WHERE
key_id = '1c2a994ca40ff4f63d4267159861c57a21fca461022d6d03e7c9ae58e5f99c2a'
AND (
token = 'pUO73cM/+EdIv2DnTrMNDZpEnJu9NoiLSI93RmiKoRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)