UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KTwc888EckOgOcJf1UYaRf/WuNI7u1DGUWbRzUW2g2s='
WHERE
key_id = '58e83087b7e475a341f83ab61c9b407484d9a5bff178de6441b790c4ed9d7201'
AND (
token = 'KTwc888EckOgOcJf1UYaRf/WuNI7u1DGUWbRzUW2g2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)