UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'u8vDNz8RRldNZGpfvy3M6o0ttDPlQUkA21hRHCU62U8='
WHERE
key_id = '2a95e0c34a5833ab3ea4372aed4469f278642447703bef873acef40916ff842b'
AND (
token = 'u8vDNz8RRldNZGpfvy3M6o0ttDPlQUkA21hRHCU62U8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)