UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FgJAjzyX4ITkP7HvT4Km09dlpbPWgeXIIp34CHNpQY4='
WHERE
key_id = '71bd4e06331dd1030895a0c3aaab8b34a166e532ca73c351d366e67d52017aaa'
AND (
token = 'FgJAjzyX4ITkP7HvT4Km09dlpbPWgeXIIp34CHNpQY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)