UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/DTMvJzR7Qra0UF8tFQP48tQToaRoWuhv1eDpCmiiD8='
WHERE
key_id = '7462a0d5a9282d3595593b983807799a995a583ec4b4ed2559de0eeb6e5be88a'
AND (
token = '/DTMvJzR7Qra0UF8tFQP48tQToaRoWuhv1eDpCmiiD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)