UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jwcyVGZ6kHlqx3EodSZxEjI935SCIbLuNm9mLdVWS+8='
WHERE
key_id = 'd467c4bc2d8bc0e6d8db87fea70fff1a4f9ae884d47bb183476b66421cb5a147'
AND (
token = 'jwcyVGZ6kHlqx3EodSZxEjI935SCIbLuNm9mLdVWS+8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)