UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '59ZWlO47cWYDUlE5chDtb3p8dzh94o9oRmJWEkxy0WM='
WHERE
key_id = '6c7be97b11e72b4a2f49a2ed2254573223c41277858f98d7eddffa8efe264fa9'
AND (
token = '59ZWlO47cWYDUlE5chDtb3p8dzh94o9oRmJWEkxy0WM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)