UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cJLi9Urt+RGRPTi4ONR8mtBGPVyzz1jzcsD46z0/CBo='
WHERE
key_id = 'bd827701be0ef20baa8df123d05912e5944de1276a0e44b1e58c7563eff28f72'
AND (
token = 'cJLi9Urt+RGRPTi4ONR8mtBGPVyzz1jzcsD46z0/CBo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)