UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'OpjXKIj8ISg2GQW1EVwmJ4OAgd1q5XV0WQHRiMq3wzk='
WHERE
key_id = '0f01308df8bf7b76c56be13f7a1233996a47707697ca1442d80495e63f1a1794'
AND (
token = 'OpjXKIj8ISg2GQW1EVwmJ4OAgd1q5XV0WQHRiMq3wzk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)