UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HNDifRNYfJvBIzej8CvFri7htRY/XQQhwsd+iwIF8e0='
WHERE
key_id = '1db3ce388ce3aefc12a84a09651c56e5eea9deb8f20f21762d14eef39dfc0e2a'
AND (
token = 'HNDifRNYfJvBIzej8CvFri7htRY/XQQhwsd+iwIF8e0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)