UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YCoNGLbNukLdRs23Ecno1SXgoZF8ewHwjoUXgCqSTnc='
WHERE
key_id = '8588f75a770ced55fbf2669e21556c56a429654f362e17f4d266634a9163d603'
AND (
token = 'YCoNGLbNukLdRs23Ecno1SXgoZF8ewHwjoUXgCqSTnc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)