UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cS0N1CNb4LBx0X23UJaWmZeoD0YBUZ3hk9+i2HzuPUM='
WHERE
key_id = '9c8921a35b7b7b6048fdd66e2a677335e796621d9960d1f32ae904eb892ee326'
AND (
token = 'cS0N1CNb4LBx0X23UJaWmZeoD0YBUZ3hk9+i2HzuPUM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)