UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4gz6sDUUFAa3H+HOLaFwU5B1ErNlPxp/AmXUCjHkPjk='
WHERE
key_id = '3e009656f05830f06f7423776966307a715065180824e38406fdb015ce95e31e'
AND (
token = '4gz6sDUUFAa3H+HOLaFwU5B1ErNlPxp/AmXUCjHkPjk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)